All Questions
Tagged with databasedesign-patterns
94 questions
21votes
5answers
4kviews
How manage inventory discrepancies due to measurement errors in warehouse management systems
I'm developing an enterprise-grade warehouse management application for a chemistry laboratory. A critical feature involves mixing multiple stock solutions to create new solutions based on predefined ...
- 321
0votes
1answer
92views
Referencing objects created during seeding by ID
I'm building a software that allows users to extract analytics from a data source. A subset of data periodically is extracted from the data source and stored in a separate database for ease of access (...
- 111
1vote
2answers
107views
Dynamic web application hitting database on front page load to fetch profile image
Folks, I am in middle of writing a web application (Python/Flask) where home page has user profile image in the navbar which is coming from a database (blob), I am wondering if this is a good practice....
- 19
-3votes
2answers
119views
Company and person or just contact table [closed]
Given the two models company and person I'm noticing duplicate fields i.e. zipcode, emailaddress for each. Yet, a short research reveals a reasonable popularity for separating those two entities into ...
- 545
2votes
2answers
182views
Pattern to transform and cache data from a DB?
We have a server that receives queries. We use the command pattern for this, e.g. q := NewQuery(database) q.Execute(request1) q.Execute(request2) The queries read a "model" from the ...
0votes
1answer
2kviews
How do Repository and Data Mapper patterns work together?
I've seen a variety of discussions talking primarily about the question of the difference or not between the Repository and Data Mapper persistence system design patterns; but I think I have a decent ...
1vote
1answer
461views
What is an apporpriate design pattern when dealing with Pandas and databases?
We're dealing with a lot of "data analysis", basically different sorts of data mangling, aggregations and calculations using Pandas. Usually, the data is time series data. All underlying ...
0votes
2answers
342views
Architecture for worker pool with different task complexities and sizes of boxes
I'm sorry if I'm using any wrong terminology here. I'm trying to design an architecture where there can be big and small tasks (e.g. processing big or small images). Big tasks can only be handled by ...
- 311
-2votes
2answers
231views
How can we implement an incremental naming system?
Just like how Mac or Windows gives incremental names to new folders, how can we implement such a system in a database? Let's say I have currently 3 folders (default names) i.e., "untitled folder&...
user16595023
0votes
1answer
30views
Interfacing with records on remote DB from localhost Application Logic
There are times when I have to fix/update records on a Production and/or Staging environment for a Web App. These are remote DBs. Rather than push application code to fix the data, I've been "...
- 103
0votes
1answer
194views
Design an extensible permissions model in database
I’m trying to model a system with Users, Permissions and Products. The main goal is to have a way of checking if a User has a specific Permission in order to allow or deny other system operations. So ...
1vote
1answer
313views
Is it a standard practice to have a single application/controller writing to database
I've been interviewed by some experienced engineer, when he strongly disagreed with some statements I said: Assuming full control over your applications, It's a standard practice to make writes-to-...
- 121
1vote
1answer
63views
Pattern for schema split across sources
I was not sure how to title this question, but bear with me. My company is building a new product and for it we will use a third-party service (let's call it ENB for short) to be responsible for many ...
- 141
0votes
0answers
81views
What is the correct way of setting and then differentiating between paid and free user in Firebase / Firestore?
I am developing a mobile application that will have both free and paid versions. The way I see how I could differentiate between what is a paid and free user is to set a property isPaid on their ...
1vote
0answers
151views
How to store relational data belonging to different client customers?
My users will be businesses with a small number of accounts each: e.g. Business #1 with 3 users, Business #2 with 5 users, etc. I am trying to determine the best way to organise the relation (on ...
- 111
